package com.jackrain.nea.fc.dl.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;

/**
 * @author wuwenxue
 * @date 2018/07/02
 **/
@Mapper
public interface ViewDLPurReqMapper {

    @Select("SELECT ID FROM PS_C_SKU " +
            "WHERE ECODE=#{ecode} AND CP_C_DISTRIB_ID=0 ")
    HashMap selSkuData(String ecode);

    @Select("SELECT ID FROM CP_C_STORE " +
            "WHERE ECODE=#{storeEcode}")
    HashMap selStoreData(String storeEcode);

}
